Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	418
Missing cells	826
Missing cells (%)	12.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	52.4 KiB
Average record size in memory	128.3 B

Variable types

Numeric	15
Categorical	1

Warnings

`df_index` is highly correlated with `Unnamed: 0`	High correlation
`Unnamed: 0` is highly correlated with `df_index`	High correlation
`Friday` has 30 (7.2%) missing values	Missing
`Monday` has 59 (14.1%) missing values	Missing
`Saturday` has 96 (23.0%) missing values	Missing
`Sunday` has 162 (38.8%) missing values	Missing
`Thursday` has 112 (26.8%) missing values	Missing
`Tuesday` has 11 (2.6%) missing values	Missing
`Wednesday` has 85 (20.3%) missing values	Missing
`ncoachingid` has 106 (25.4%) missing values	Missing
`total coaching improved` has 162 (38.8%) missing values	Missing
`df_index` has unique values	Unique
`Unnamed: 0` has unique values	Unique

Reproduction

Analysis started	2021-05-13 18:56:02.490545
Analysis finished	2021-05-13 18:56:45.360257
Duration	42.87 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	418
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	248.4641148
Minimum	3
Maximum	488
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	3
5-th percentile	29.85
Q1	125.25
median	250
Q3	374.75
95-th percentile	465.15
Maximum	488
Range	485
Interquartile range (IQR)	249.5

Descriptive statistics

Standard deviation	141.3334405
Coefficient of variation (CV)	0.5688283822
Kurtosis	-1.236389434
Mean	248.4641148
Median Absolute Deviation (MAD)	125
Skewness	-0.01755172389
Sum	103858
Variance	19975.1414
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	1	0.2%
375	1	0.2%
338	1	0.2%
337	1	0.2%
336	1	0.2%
335	1	0.2%
334	1	0.2%
333	1	0.2%
332	1	0.2%
331	1	0.2%
Other values (408)	408	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	0.2%
4	1	0.2%
7	1	0.2%
8	1	0.2%
10	1	0.2%

Value	Count	Frequency (%)
488	1	0.2%
487	1	0.2%
486	1	0.2%
485	1	0.2%
484	1	0.2%

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	418
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	248.4641148
Minimum	3
Maximum	488
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	3
5-th percentile	29.85
Q1	125.25
median	250
Q3	374.75
95-th percentile	465.15
Maximum	488
Range	485
Interquartile range (IQR)	249.5

Descriptive statistics

Standard deviation	141.3334405
Coefficient of variation (CV)	0.5688283822
Kurtosis	-1.236389434
Mean	248.4641148
Median Absolute Deviation (MAD)	125
Skewness	-0.01755172389
Sum	103858
Variance	19975.1414
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	1	0.2%
375	1	0.2%
338	1	0.2%
337	1	0.2%
336	1	0.2%
335	1	0.2%
334	1	0.2%
333	1	0.2%
332	1	0.2%
331	1	0.2%
Other values (408)	408	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	0.2%
4	1	0.2%
7	1	0.2%
8	1	0.2%
10	1	0.2%

Value	Count	Frequency (%)
488	1	0.2%
487	1	0.2%
486	1	0.2%
485	1	0.2%
484	1	0.2%

employeeid
Real number (ℝ_≥0)

Distinct	273
Distinct (%)	65.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	26768058.64
Minimum	26702507
Maximum	35706317
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	26702507
5-th percentile	26702701.15
Q1	26703200.75
median	26703526
Q3	26703807
95-th percentile	26703958.45
Maximum	35706317
Range	9003810
Interquartile range (IQR)	606.25

Descriptive statistics

Standard deviation	760868.2483
Coefficient of variation (CV)	0.02842448377
Kurtosis	135.9758747
Mean	26768058.64
Median Absolute Deviation (MAD)	294.5
Skewness	11.71858564
Sum	1.118904851 × 10¹⁰
Variance	5.789204912 × 10¹¹
Monotocity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26703700	3	0.7%
26703220	3	0.7%
26703302	3	0.7%
26703897	3	0.7%
26703818	3	0.7%
26703315	3	0.7%
26703378	3	0.7%
26703308	3	0.7%
26703194	3	0.7%
26703553	3	0.7%
Other values (263)	388	92.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
26702507	2	0.5%
26702537	2	0.5%
26702549	2	0.5%
26702594	1	0.2%
26702611	1	0.2%

Value	Count	Frequency (%)
35706317	2	0.5%
35706305	1	0.2%
26703983	1	0.2%
26703982	2	0.5%
26703979	1	0.2%

Friday
Real number (ℝ_≥0)

MISSING

Distinct	139
Distinct (%)	35.8%
Missing	30
Missing (%)	7.2%
Infinite	0
Infinite (%)	0.0%

Mean	95.26657223
Minimum	67.8575
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	67.8575
5-th percentile	83.33375
Q1	93.334
median	96.186
Q3	100
95-th percentile	100
Maximum	100
Range	32.1425
Interquartile range (IQR)	6.666

Descriptive statistics

Standard deviation	5.3706653
Coefficient of variation (CV)	0.05637512902
Kurtosis	4.677514818
Mean	95.26657223
Median Absolute Deviation (MAD)	3.814
Skewness	-1.862301056
Sum	36963.43002
Variance	28.84404577
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	120	28.7%
93.75	7	1.7%
93.334	6	1.4%
95	6	1.4%
90	5	1.2%
95.83333333	5	1.2%
95.23857143	5	1.2%
98.4375	4	1.0%
94.445	4	1.0%
87.5	4	1.0%
Other values (129)	222	53.1%
(Missing)	30	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
67.8575	2	0.5%
75	2	0.5%
77.78	1	0.2%
78.334	3	0.7%
79.11375	1	0.2%

Value	Count	Frequency (%)
100	120	28.7%
99.03875	2	0.5%
98.86375	1	0.2%
98.71833333	3	0.7%
98.61125	2	0.5%

Monday
Real number (ℝ_≥0)

MISSING

Distinct	139
Distinct (%)	38.7%
Missing	59
Missing (%)	14.1%
Infinite	0
Infinite (%)	0.0%

Mean	94.40371216
Minimum	70.8325
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	70.8325
5-th percentile	83.334875
Q1	91.66666667
median	95.3125
Q3	100
95-th percentile	100
Maximum	100
Range	29.1675
Interquartile range (IQR)	8.333333333

Descriptive statistics

Standard deviation	5.534483123
Coefficient of variation (CV)	0.0586256938
Kurtosis	1.984383172
Mean	94.40371216
Median Absolute Deviation (MAD)	3.64625
Skewness	-1.286373458
Sum	33890.93267
Variance	30.63050344
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	92	22.0%
96.29666667	8	1.9%
87.5	7	1.7%
96.4275	5	1.2%
94.44333333	5	1.2%
95	5	1.2%
91.66666667	5	1.2%
90.27833333	4	1.0%
93.33333333	4	1.0%
98.14777778	4	1.0%
Other values (129)	220	52.6%
(Missing)	59	14.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70.8325	1	0.2%
73.01333333	2	0.5%
75	2	0.5%
78.476	1	0.2%
80	1	0.2%

Value	Count	Frequency (%)
100	92	22.0%
98.95875	2	0.5%
98.76555556	2	0.5%
98.75	2	0.5%
98.61125	1	0.2%

Saturday
Real number (ℝ_≥0)

MISSING

Distinct	109
Distinct (%)	33.9%
Missing	96
Missing (%)	23.0%
Infinite	0
Infinite (%)	0.0%

Mean	95.45384609
Minimum	77.77666667
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	77.77666667
5-th percentile	86.174225
Q1	92.62825893
median	96.295
Q3	100
95-th percentile	100
Maximum	100
Range	22.22333333
Interquartile range (IQR)	7.371741071

Descriptive statistics

Standard deviation	4.429498899
Coefficient of variation (CV)	0.04640461418
Kurtosis	1.164433239
Mean	95.45384609
Median Absolute Deviation (MAD)	3.705
Skewness	-1.086387768
Sum	30736.13844
Variance	19.6204605
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	93	22.2%
91.66666667	7	1.7%
97.91666667	6	1.4%
91.6675	6	1.4%
96.4275	5	1.2%
92.5	5	1.2%
92.85714286	4	1.0%
95	4	1.0%
93.75	4	1.0%
98.21428571	4	1.0%
Other values (99)	184	44.0%
(Missing)	96	23.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
77.77666667	2	0.5%
81.99375	2	0.5%
83.335	1	0.2%
84.62	2	0.5%
84.72166667	2	0.5%

Value	Count	Frequency (%)
100	93	22.2%
99.04714286	1	0.2%
98.75	2	0.5%
98.57142857	2	0.5%
98.462	1	0.2%

Sunday
Real number (ℝ_≥0)

MISSING

Distinct	92
Distinct (%)	35.9%
Missing	162
Missing (%)	38.8%
Infinite	0
Infinite (%)	0.0%

Mean	94.73439318
Minimum	50
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	50
5-th percentile	85.71
Q1	92.466
median	95.989375
Q3	100
95-th percentile	100
Maximum	100
Range	50
Interquartile range (IQR)	7.534

Descriptive statistics

Standard deviation	6.077321404
Coefficient of variation (CV)	0.064151162
Kurtosis	14.79243065
Mean	94.73439318
Median Absolute Deviation (MAD)	3.818
Skewness	-2.983538347
Sum	24252.00465
Variance	36.93383545
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	65	15.6%
96.42857143	11	2.6%
91.665	5	1.2%
98.41285714	5	1.2%
93.75	4	1.0%
92.5	4	1.0%
97.5	4	1.0%
95	4	1.0%
75	4	1.0%
95.57714286	3	0.7%
Other values (82)	147	35.2%
(Missing)	162	38.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	1	0.2%
66.67	2	0.5%
75	4	1.0%
80	1	0.2%
83.33333333	1	0.2%

Value	Count	Frequency (%)
100	65	15.6%
98.70142857	3	0.7%
98.61125	2	0.5%
98.57142857	2	0.5%
98.41285714	5	1.2%

Thursday
Real number (ℝ_≥0)

MISSING

Distinct	138
Distinct (%)	45.1%
Missing	112
Missing (%)	26.8%
Infinite	0
Infinite (%)	0.0%

Mean	94.22196663
Minimum	57.5
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	57.5
5-th percentile	82.17229167
Q1	91.666875
median	95.758375
Q3	98.41145833
95-th percentile	100
Maximum	100
Range	42.5
Interquartile range (IQR)	6.744583333

Descriptive statistics

Standard deviation	5.895095966
Coefficient of variation (CV)	0.06256604672
Kurtosis	5.525973135
Mean	94.22196663
Median Absolute Deviation (MAD)	3.827819444
Skewness	-1.8286406
Sum	28831.92179
Variance	34.75215645
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	73	17.5%
95	7	1.7%
94.445	6	1.4%
95.83375	5	1.2%
96.666	5	1.2%
91.665	4	1.0%
91.66666667	4	1.0%
96.875	4	1.0%
90	4	1.0%
93.75	4	1.0%
Other values (128)	190	45.5%
(Missing)	112	26.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
57.5	1	0.2%
74.182	1	0.2%
75	2	0.5%
76.666	2	0.5%
77.77666667	1	0.2%

Value	Count	Frequency (%)
100	73	17.5%
98.76555556	2	0.5%
98.485	1	0.2%
98.4375	1	0.2%
98.33333333	1	0.2%

Tuesday
Real number (ℝ_≥0)

MISSING

Distinct	166
Distinct (%)	40.8%
Missing	11
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%

Mean	95.19500538
Minimum	61.666
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	61.666
5-th percentile	86.91156944
Q1	93.44666667
median	96.01
Q3	98.4375
95-th percentile	100
Maximum	100
Range	38.334
Interquartile range (IQR)	4.990833333

Descriptive statistics

Standard deviation	4.89017773
Coefficient of variation (CV)	0.05137010823
Kurtosis	11.25529773
Mean	95.19500538
Median Absolute Deviation (MAD)	2.45
Skewness	-2.478488807
Sum	38744.36719
Variance	23.91383823
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	90	21.5%
93.75	11	2.6%
95.83333333	7	1.7%
95.23857143	6	1.4%
96.875	5	1.2%
87.5	5	1.2%
88.095	5	1.2%
97.778	4	1.0%
95.23666667	4	1.0%
96.666	4	1.0%
Other values (156)	266	63.6%
(Missing)	11	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
61.666	1	0.2%
65	1	0.2%
67.06333333	1	0.2%
75.258	1	0.2%
79.63	1	0.2%

Value	Count	Frequency (%)
100	90	21.5%
99.16625	2	0.5%
98.98	2	0.5%
98.86375	1	0.2%
98.76555556	2	0.5%

Wednesday
Real number (ℝ_≥0)

MISSING

Distinct	120
Distinct (%)	36.0%
Missing	85
Missing (%)	20.3%
Infinite	0
Infinite (%)	0.0%

Mean	94.91694048
Minimum	50
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	50
5-th percentile	82.84125
Q1	92.855
median	96.66666667
Q3	100
95-th percentile	100
Maximum	100
Range	50
Interquartile range (IQR)	7.145

Descriptive statistics

Standard deviation	7.137471218
Coefficient of variation (CV)	0.07519702154
Kurtosis	17.53841737
Mean	94.91694048
Median Absolute Deviation (MAD)	3.333333333
Skewness	-3.472652892
Sum	31607.34118
Variance	50.94349538
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	113	27.0%
96.66666667	6	1.4%
97.22222222	5	1.2%
97.77777778	5	1.2%
91.66714286	4	1.0%
50	4	1.0%
95	4	1.0%
96	4	1.0%
80	4	1.0%
93.33333333	4	1.0%
Other values (110)	180	43.1%
(Missing)	85	20.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	4	1.0%
73.334	1	0.2%
77.444	2	0.5%
78.03	1	0.2%
80	4	1.0%

Value	Count	Frequency (%)
100	113	27.0%
98.95875	1	0.2%
98.86375	1	0.2%
98.76555556	1	0.2%
98.462	1	0.2%

weekbefore
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	5.1%
Missing	3
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	95.17792771
Minimum	33.33
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	33.33
5-th percentile	75
Q1	93.33
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	66.67
Interquartile range (IQR)	6.67

Descriptive statistics

Standard deviation	9.941633267
Coefficient of variation (CV)	0.1044531385
Kurtosis	8.202619695
Mean	95.17792771
Median Absolute Deviation (MAD)	0
Skewness	-2.618370844
Sum	39498.84
Variance	98.83607202
Monotocity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
100	308	73.7%
83.33	13	3.1%
80	13	3.1%
75	12	2.9%
88.89	12	2.9%
85.71	8	1.9%
90	7	1.7%
87.5	6	1.4%
50	5	1.2%
66.67	5	1.2%
Other values (11)	26	6.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
33.33	1	0.2%
50	5	1.2%
60	1	0.2%
66.67	5	1.2%
71.43	3	0.7%

Value	Count	Frequency (%)
100	308	73.7%
94.44	1	0.2%
93.33	4	1.0%
92.86	1	0.2%
92.31	3	0.7%

ncoachingid
Real number (ℝ_≥0)

MISSING

Distinct	15
Distinct (%)	4.8%
Missing	106
Missing (%)	25.4%
Infinite	0
Infinite (%)	0.0%

Mean	3.496794872
Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	9
Maximum	16
Range	15
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.871299825
Coefficient of variation (CV)	0.821123323
Kurtosis	4.893527961
Mean	3.496794872
Median Absolute Deviation (MAD)	1
Skewness	2.04125621
Sum	1091
Variance	8.244362684
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
2	81	19.4%
1	68	16.3%
3	60	14.4%
4	32	7.7%
5	17	4.1%
6	14	3.3%
7	12	2.9%
9	8	1.9%
10	6	1.4%
8	5	1.2%
Other values (5)	9	2.2%
(Missing)	106	25.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	68	16.3%
2	81	19.4%
3	60	14.4%
4	32	7.7%
5	17	4.1%

Value	Count	Frequency (%)
16	4	1.0%
14	2	0.5%
13	1	0.2%
12	1	0.2%
11	1	0.2%

total coaching improved
Real number (ℝ_≥0)

MISSING

Distinct	8
Distinct (%)	3.1%
Missing	162
Missing (%)	38.8%
Infinite	0
Infinite (%)	0.0%

Mean	2.375
Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	5.25
Maximum	8
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.571810496
Coefficient of variation (CV)	0.6618149457
Kurtosis	1.422620542
Mean	2.375
Median Absolute Deviation (MAD)	1
Skewness	1.31068121
Sum	608
Variance	2.470588235
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	99	23.7%
2	64	15.3%
3	40	9.6%
4	27	6.5%
5	13	3.1%
7	6	1.4%
6	5	1.2%
8	2	0.5%
(Missing)	162	38.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	99	23.7%
2	64	15.3%
3	40	9.6%
4	27	6.5%
5	13	3.1%

Value	Count	Frequency (%)
8	2	0.5%
7	6	1.4%
6	5	1.2%
5	13	3.1%
4	27	6.5%

csat
Real number (ℝ_≥0)

Distinct	219
Distinct (%)	52.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	94.86746411
Minimum	79.26
Maximum	99.22
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	79.26
5-th percentile	91.947
Q1	93.97
median	95.085
Q3	96.0625
95-th percentile	97.16
Maximum	99.22
Range	19.96
Interquartile range (IQR)	2.0925

Descriptive statistics

Standard deviation	1.833150053
Coefficient of variation (CV)	0.01932327453
Kurtosis	12.43087158
Mean	94.86746411
Median Absolute Deviation (MAD)	1.095
Skewness	-1.910173617
Sum	39654.6
Variance	3.360439117
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94.41	7	1.7%
95.78	6	1.4%
94.78	5	1.2%
95.47	5	1.2%
95.52	4	1.0%
94.64	4	1.0%
95.85	4	1.0%
96.01	4	1.0%
94.08	4	1.0%
95.58	4	1.0%
Other values (209)	371	88.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
79.26	1	0.2%
88.75	1	0.2%
88.83	1	0.2%
89.13	1	0.2%
89.61	1	0.2%

Value	Count	Frequency (%)
99.22	2	0.5%
98.46	1	0.2%
98.14	1	0.2%
98	2	0.5%
97.99	2	0.5%

actualvalue
Real number (ℝ_≥0)

Distinct	74
Distinct (%)	17.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	94.36593301
Minimum	50
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.4 KiB

Quantile statistics

Minimum	50
5-th percentile	85.4535
Q1	91.3
median	95.74
Q3	100
95-th percentile	100
Maximum	100
Range	50
Interquartile range (IQR)	8.7

Descriptive statistics

Standard deviation	5.818415338
Coefficient of variation (CV)	0.06165800678
Kurtosis	9.862377143
Mean	94.36593301
Median Absolute Deviation (MAD)	4.26
Skewness	-2.152489284
Sum	39444.96
Variance	33.85395704
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	116	27.8%
90	14	3.3%
94.44	11	2.6%
88.89	11	2.6%
91.67	10	2.4%
92.31	10	2.4%
90.91	9	2.2%
96.67	9	2.2%
96.88	8	1.9%
95.65	8	1.9%
Other values (64)	212	50.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	1	0.2%
66.67	2	0.5%
75	1	0.2%
76.92	2	0.5%
77.78	2	0.5%

Value	Count	Frequency (%)
100	116	27.8%
98.25	3	0.7%
98.04	2	0.5%
97.87	4	1.0%
97.67	1	0.2%

actualvalue_class
Categorical

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.4 KiB

0	222
1	196

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	418
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	222	53.1%
1	196	46.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	222	53.1%
1	196	46.9%

Most occurring characters

Value	Count	Frequency (%)
0	222	53.1%
1	196	46.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	418	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	222	53.1%
1	196	46.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	418	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	222	53.1%
1	196	46.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	418	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	222	53.1%
1	196	46.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Unnamed: 0	employeeid	Friday	Monday	Saturday	Sunday	Thursday	Tuesday	Wednesday	weekbefore	ncoachingid	total coaching improved	csat	actualvalue	actualvalue_class
0	3	3	26702507	91.468000	91.880000	100.000000	91.112000	NaN	96.666000	NaN	80.0	NaN	NaN	95.52	90.00	0
1	4	4	26702507	91.468000	91.880000	100.000000	91.112000	NaN	96.666000	NaN	100.0	NaN	NaN	95.52	90.00	0
2	7	7	26702537	100.000000	88.527143	100.000000	95.832857	NaN	95.713750	NaN	100.0	1.0	1.0	96.63	88.89	0
3	8	8	26702537	100.000000	88.527143	100.000000	95.832857	NaN	95.713750	NaN	100.0	1.0	1.0	96.63	88.89	0
4	10	10	26702549	100.000000	98.147778	92.857143	96.428571	NaN	96.875000	100.000000	100.0	1.0	1.0	97.99	80.00	0
5	11	11	26702549	100.000000	98.147778	92.857143	96.428571	NaN	96.875000	100.000000	80.0	1.0	1.0	97.99	80.00	0
6	14	14	26702594	100.000000	94.445000	89.286667	NaN	93.333333	95.101429	100.000000	100.0	1.0	NaN	96.19	100.00	1
7	15	15	26702611	95.303333	100.000000	NaN	NaN	97.281111	97.222222	98.765556	100.0	2.0	NaN	95.14	100.00	1
8	16	16	26702617	96.984286	91.111111	95.221429	95.328571	NaN	97.601111	NaN	100.0	NaN	NaN	93.87	97.06	1
9	17	17	26702617	96.984286	91.111111	95.221429	95.328571	NaN	97.601111	NaN	100.0	NaN	NaN	93.87	97.06	1

Last rows

	df_index	Unnamed: 0	employeeid	Friday	Monday	Saturday	Sunday	Thursday	Tuesday	Wednesday	weekbefore	ncoachingid	total coaching improved	csat	actualvalue	actualvalue_class
408	478	478	26703973	93.333333	100.000000	NaN	NaN	90.000000	96.427500	78.030000	100.00	NaN	NaN	96.97	100.00	1
409	479	479	26703977	90.177500	100.000000	NaN	NaN	86.000000	61.666000	92.666000	100.00	NaN	NaN	79.26	92.86	1
410	480	480	26703978	100.000000	100.000000	NaN	NaN	96.666000	100.000000	73.334000	100.00	NaN	NaN	96.94	88.24	0
411	481	481	26703979	93.333333	96.427500	NaN	NaN	96.427500	100.000000	100.000000	100.00	NaN	NaN	97.46	100.00	1
412	483	483	26703982	93.750000	94.443333	NaN	NaN	82.666000	95.556000	91.667500	100.00	NaN	NaN	97.01	93.18	0
413	484	484	26703982	93.750000	94.443333	NaN	NaN	82.666000	95.556000	91.667500	100.00	NaN	NaN	97.01	93.18	0
414	485	485	26703983	83.335000	95.832500	NaN	NaN	100.000000	100.000000	100.000000	100.00	NaN	NaN	91.54	88.89	1
415	486	486	35706305	NaN	92.000000	NaN	93.334	79.167500	87.500000	91.667500	100.00	5.0	4.0	95.95	87.50	0
416	487	487	35706317	81.770000	NaN	81.99375	NaN	87.213333	86.837778	86.648889	33.33	16.0	4.0	96.68	88.46	1
417	488	488	35706317	81.770000	NaN	81.99375	NaN	87.213333	86.837778	86.648889	50.00	16.0	4.0	96.68	88.46	1

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows